SELECT p.iPostID, p.iPostType, p.iAdType, p.iUserType, p.strTitle, p.iSubType, p.iItemType, p.iPrice, p.iPriceUnit, json_unquote(p.jsonLocation->"$.city") AS city, p.jsonExtra, p.tmPosted, p.iShowImg, p.strImages, p.strVideos, p.strPostURL FROM posts p WHERE p.iActive=1 AND p.iPostType=1 AND iPostID IN (SELECT t.iPostID FROM posttext t WHERE t.iDomID=101 AND MATCH (t.strSearch) AGAINST ('+house +real +estate +websites' IN BOOLEAN MODE)) AND iCityID IN (69815,69237,68053,70162,69540,70076,69902,69943,68692,68975,68180,69221,69751,68717,68318,67560,68751,68171,69940,68436,67746,67564,68932) ORDER BY FIELD(iCityID, 69815,69237,68053,70162,69540,70076,69902,69943,68692,68975,68180,69221,69751,68717,68318,67560,68751,68171,69940,68436,67746,67564,68932) ASC, p.tmPosted DESC LIMIT 24